File manager

File manager - Edit - /home/autoph/public_html/projects/public/storage/generated_payrolls/Y7bhjSaZxRm4gTdPld09MMK7VHDLXKKx9LAM2g0n.xlsx

Back
PK��3H\��\��xl/_rels/workbook.xml.rels<?xml version="1.0" encoding="UTF-8" standalone="yes"?> <Relationships xmlns="http://schemas.openxmlformats.org/package/2006/relationships"><Relationship Id="rId1" Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/worksheet" Target="worksheets/sheet1.xml"/><Relationship Id="rId2" Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/worksheet" Target="worksheets/sheet2.xml"/><Relationship Id="rId3" Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/worksheet" Target="worksheets/sheet3.xml"/><Relationship Id="rId4" Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/worksheet" Target="worksheets/sheet4.xml"/><Relationship Id="rId5" Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/theme" Target="theme/theme1.xml"/><Relationship Id="rId6" Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/styles" Target="styles.xml"/><Relationship Id="rId7" Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/sheetMetadata" Target="metadata.xml"/></Relationships>PK��0�k��xl/theme/theme1.xml<?xml version="1.0" encoding="UTF-8" standalone="yes"?> <a:theme xmlns:a="http://schemas.openxmlformats.org/drawingml/2006/main" name="Office Theme"><a:themeElements><a:clrScheme name="Office"><a:dk1><a:sysClr val="windowText" lastClr="000000"/></a:dk1><a:lt1><a:sysClr val="window" lastClr="FFFFFF"/></a:lt1><a:dk2><a:srgbClr val="1F497D"/></a:dk2><a:lt2><a:srgbClr val="EEECE1"/></a:lt2><a:accent1><a:srgbClr val="4F81BD"/></a:accent1><a:accent2><a:srgbClr val="C0504D"/></a:accent2><a:accent3><a:srgbClr val="9BBB59"/></a:accent3><a:accent4><a:srgbClr val="8064A2"/></a:accent4><a:accent5><a:srgbClr val="4BACC6"/></a:accent5><a:accent6><a:srgbClr val="F79646"/></a:accent6><a:hlink><a:srgbClr val="0000FF"/></a:hlink><a:folHlink><a:srgbClr val="800080"/></a:folHlink></a:clrScheme><a:fontScheme name="Office"><a:majorFont><a:latin typeface="Cambria"/><a:ea typeface=""/><a:cs typeface=""/><a:font script="Jpan" typeface="ＭＳＰゴシック"/><a:font script="Hang" typeface="맑은 고딕"/><a:font script="Hans" typeface="宋体"/><a:font script="Hant" typeface="新細明體"/><a:font script="Arab" typeface="Times New Roman"/><a:font script="Hebr" typeface="Times New Roman"/><a:font script="Thai" typeface="Tahoma"/><a:font script="Ethi" typeface="Nyala"/><a:font script="Beng" typeface="Vrinda"/><a:font script="Gujr" typeface="Shruti"/><a:font script="Khmr" typeface="MoolBoran"/><a:font script="Knda" typeface="Tunga"/><a:font script="Guru" typeface="Raavi"/><a:font script="Cans" typeface="Euphemia"/><a:font script="Cher" typeface="Plantagenet Cherokee"/><a:font script="Yiii" typeface="Microsoft Yi Baiti"/><a:font script="Tibt" typeface="Microsoft Himalaya"/><a:font script="Thaa" typeface="MV Boli"/><a:font script="Deva" typeface="Mangal"/><a:font script="Telu" typeface="Gautami"/><a:font script="Taml" typeface="Latha"/><a:font script="Syrc" typeface="Estrangelo Edessa"/><a:font script="Orya" typeface="Kalinga"/><a:font script="Mlym" typeface="Kartika"/><a:font script="Laoo" typeface="DokChampa"/><a:font script="Sinh" typeface="Iskoola Pota"/><a:font script="Mong" typeface="Mongolian Baiti"/><a:font script="Viet" typeface="Times New Roman"/><a:font script="Uigh" typeface="Microsoft Uighur"/><a:font script="Geor" typeface="Sylfaen"/></a:majorFont><a:minorFont><a:latin typeface="Calibri"/><a:ea typeface=""/><a:cs typeface=""/><a:font script="Jpan" typeface="ＭＳＰゴシック"/><a:font script="Hang" typeface="맑은 고딕"/><a:font script="Hans" typeface="宋体"/><a:font script="Hant" typeface="新細明體"/><a:font script="Arab" typeface="Arial"/><a:font script="Hebr" typeface="Arial"/><a:font script="Thai" typeface="Tahoma"/><a:font script="Ethi" typeface="Nyala"/><a:font script="Beng" typeface="Vrinda"/><a:font script="Gujr" typeface="Shruti"/><a:font script="Khmr" typeface="DaunPenh"/><a:font script="Knda" typeface="Tunga"/><a:font script="Guru" typeface="Raavi"/><a:font script="Cans" typeface="Euphemia"/><a:font script="Cher" typeface="Plantagenet Cherokee"/><a:font script="Yiii" typeface="Microsoft Yi Baiti"/><a:font script="Tibt" typeface="Microsoft Himalaya"/><a:font script="Thaa" typeface="MV Boli"/><a:font script="Deva" typeface="Mangal"/><a:font script="Telu" typeface="Gautami"/><a:font script="Taml" typeface="Latha"/><a:font script="Syrc" typeface="Estrangelo Edessa"/><a:font script="Orya" typeface="Kalinga"/><a:font script="Mlym" typeface="Kartika"/><a:font script="Laoo" typeface="DokChampa"/><a:font script="Sinh" typeface="Iskoola Pota"/><a:font script="Mong" typeface="Mongolian Baiti"/><a:font script="Viet" typeface="Arial"/><a:font script="Uigh" typeface="Microsoft Uighur"/><a:font script="Geor" typeface="Sylfaen"/></a:minorFont></a:fontScheme><a:fmtScheme name="Office"><a:fillStyleLst><a:solidFill><a:schemeClr val="phClr"/></a:solidFill><a:gradFill rotWithShape="1"><a:gsLst><a:gs pos="0"><a:schemeClr val="phClr"><a:tint val="50000"/><a:satMod val="300000"/></a:schemeClr></a:gs><a:gs pos="35000"><a:schemeClr val="phClr"><a:tint val="37000"/><a:satMod val="300000"/></a:schemeClr></a:gs><a:gs pos="100000"><a:schemeClr val="phClr"><a:tint val="15000"/><a:satMod val="350000"/></a:schemeClr></a:gs></a:gsLst><a:lin ang="16200000" scaled="1"/></a:gradFill><a:gradFill rotWithShape="1"><a:gsLst><a:gs pos="0"><a:schemeClr val="phClr"><a:tint val="100000"/><a:shade val="100000"/><a:satMod val="130000"/></a:schemeClr></a:gs><a:gs pos="100000"><a:schemeClr val="phClr"><a:tint val="50000"/><a:shade val="100000"/><a:satMod val="350000"/></a:schemeClr></a:gs></a:gsLst><a:lin ang="16200000" scaled="0"/></a:gradFill></a:fillStyleLst><a:lnStyleLst><a:ln w="9525" cap="flat" cmpd="sng" algn="ctr"><a:solidFill><a:schemeClr val="phClr"><a:shade val="95000"/><a:satMod val="105000"/></a:schemeClr></a:solidFill><a:prstDash val="solid"/></a:ln><a:ln w="25400" cap="flat" cmpd="sng" algn="ctr"><a:solidFill><a:schemeClr val="phClr"/></a:solidFill><a:prstDash val="solid"/></a:ln><a:ln w="38100" cap="flat" cmpd="sng" algn="ctr"><a:solidFill><a:schemeClr val="phClr"/></a:solidFill><a:prstDash val="solid"/></a:ln></a:lnStyleLst><a:effectStyleLst><a:effectStyle><a:effectLst><a:outerShdw blurRad="40000" dist="20000" dir="5400000" rotWithShape="0"><a:srgbClr val="000000"><a:alpha val="38000"/></a:srgbClr></a:outerShdw></a:effectLst></a:effectStyle><a:effectStyle><a:effectLst><a:outerShdw blurRad="40000" dist="23000" dir="5400000" rotWithShape="0"><a:srgbClr val="000000"><a:alpha val="35000"/></a:srgbClr></a:outerShdw></a:effectLst></a:effectStyle><a:effectStyle><a:effectLst><a:outerShdw blurRad="40000" dist="23000" dir="5400000" rotWithShape="0"><a:srgbClr val="000000"><a:alpha val="35000"/></a:srgbClr></a:outerShdw></a:effectLst><a:scene3d><a:camera prst="orthographicFront"><a:rot lat="0" lon="0" rev="0"/></a:camera><a:lightRig rig="threePt" dir="t"><a:rot lat="0" lon="0" rev="1200000"/></a:lightRig></a:scene3d><a:sp3d><a:bevelT w="63500" h="25400"/></a:sp3d></a:effectStyle></a:effectStyleLst><a:bgFillStyleLst><a:solidFill><a:schemeClr val="phClr"/></a:solidFill><a:gradFill rotWithShape="1"><a:gsLst><a:gs pos="0"><a:schemeClr val="phClr"><a:tint val="40000"/><a:satMod val="350000"/></a:schemeClr></a:gs><a:gs pos="40000"><a:schemeClr val="phClr"><a:tint val="45000"/><a:shade val="99000"/><a:satMod val="350000"/></a:schemeClr></a:gs><a:gs pos="100000"><a:schemeClr val="phClr"><a:shade val="20000"/><a:satMod val="255000"/></a:schemeClr></a:gs></a:gsLst><a:path path="circle"><a:fillToRect l="50000" t="-80000" r="50000" b="180000"/></a:path></a:gradFill><a:gradFill rotWithShape="1"><a:gsLst><a:gs pos="0"><a:schemeClr val="phClr"><a:tint val="80000"/><a:satMod val="300000"/></a:schemeClr></a:gs><a:gs pos="100000"><a:schemeClr val="phClr"><a:shade val="30000"/><a:satMod val="200000"/></a:schemeClr></a:gs></a:gsLst><a:path path="circle"><a:fillToRect l="50000" t="50000" r="50000" b="50000"/></a:path></a:gradFill></a:bgFillStyleLst></a:fmtScheme></a:themeElements><a:objectDefaults><a:spDef><a:spPr/><a:bodyPr/><a:lstStyle/><a:style><a:lnRef idx="1"><a:schemeClr val="accent1"/></a:lnRef><a:fillRef idx="3"><a:schemeClr val="accent1"/></a:fillRef><a:effectRef idx="2"><a:schemeClr val="accent1"/></a:effectRef><a:fontRef idx="minor"><a:schemeClr val="lt1"/></a:fontRef></a:style></a:spDef><a:lnDef><a:spPr/><a:bodyPr/><a:lstStyle/><a:style><a:lnRef idx="2"><a:schemeClr val="accent1"/></a:lnRef><a:fillRef idx="0"><a:schemeClr val="accent1"/></a:fillRef><a:effectRef idx="1"><a:schemeClr val="accent1"/></a:effectRef><a:fontRef idx="minor"><a:schemeClr val="tx1"/></a:fontRef></a:style></a:lnDef></a:objectDefaults><a:extraClrSchemeLst/></a:theme>PK��U��Z��Z�� xl/styles.xml<?xml version="1.0" encoding="UTF-8" standalone="yes"?> <styleSheet xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" xmlns:vt="http://schemas.openxmlformats.org/officeDocument/2006/docPropsVTypes"><numFmts count="1"><numFmt numFmtId="56" formatCode=""上午/下午 "hh"時"mm"分"ss"秒 ""/></numFmts><fonts count="1"><font><sz val="12"/><color theme="1"/><name val="Calibri"/><family val="2"/><scheme val="minor"/></font></fonts><fills count="2"><fill><patternFill patternType="none"/></fill><fill><patternFill patternType="gray125"/></fill></fills><borders count="1"><border><left/><right/><top/><bottom/><diagonal/></border></borders><cellStyleXfs count="1"><xf numFmtId="0" fontId="0" fillId="0" borderId="0"/></cellStyleXfs><cellXfs count="1"><xf numFmtId="0" fontId="0" fillId="0" borderId="0" xfId="0" applyNumberFormat="1"/></cellXfs><cellStyles count="1"><cellStyle name="Normal" xfId="0" builtinId="0"/></cellStyles><dxfs count="0"/><tableStyles count="0" defaultTableStyle="TableStyleMedium9" defaultPivotStyle="PivotStyleMedium4"/></styleSheet>PK��P��X/��X/��xl/worksheets/sheet1.xml<?xml version="1.0" encoding="UTF-8" standalone="yes"?> <worksheet xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships"><dimension ref="A1:AA19"/><sheetViews><sheetView workbookViewId="0"/></sheetViews><sheetData><row r="1"><c r="A1" t="str"><v>AHG - AUTOHUB GROUP BUSINESS AND CONSULTANCY SERVICES, INC</v></c></row><row r="2"><c r="A2" t="str"><v>PAYROLL SUMMARY REPORT</v></c></row><row r="3"><c r="A3" t="str"><v>Payroll Date : 09/30/2024</v></c></row><row r="4"><c r="A4" t="str"><v>Cutoff Date : 09/06/2024 - 09/20/2024</v></c></row><row r="5"><c r="A5" t="str"><v>Branch : AUTOHUB GROUP INC</v></c></row><row r="6"><c r="A6" t="str"><v>Employee</v></c><c r="B6" t="str"><v>Department</v></c><c r="C6" t="str"><v>Monthly Salary</v></c><c r="D6" t="str"><v>Work Days</v></c><c r="E6" t="str"><v>Work Hours</v></c><c r="F6" t="str"><v>Basic Pay</v></c><c r="G6" t="str"><v>Other Income</v></c><c r="H6" t="str"><v>Leave</v></c><c r="I6" t="str"><v>Overtime</v></c><c r="J6" t="str"><v>Holiday</v></c><c r="K6" t="str"><v>Restday</v></c><c r="L6" t="str"><v>Night Diff</v></c><c r="M6" t="str"><v>Absent</v></c><c r="N6" t="str"><v>Late</v></c><c r="O6" t="str"><v>Undertime</v></c><c r="P6" t="str"><v>Gross Pay</v></c><c r="Q6" t="str"><v>SSS</v></c><c r="R6" t="str"><v>Philhealth</v></c><c r="S6" t="str"><v>Pagibig</v></c><c r="T6" t="str"><v>Taxable Amount</v></c><c r="U6" t="str"><v>Withholding Tax</v></c><c r="V6" t="str"><v>Income after tax</v></c><c r="W6" t="str"><v>Benefits</v></c><c r="X6" t="str"><v>Loans</v></c><c r="Y6" t="str"><v>Adjustments</v></c><c r="Z6" t="str"><v>Deductions</v></c><c r="AA6" t="str"><v>Net Pay</v></c></row><row r="7"><c r="A7" t="str"><v>Arruiza, Bush Ceazar (60699)</v></c><c r="B7" t="str"><v>APP. DEV & DATABASE</v></c><c r="C7"><v>25000</v></c><c r="F7"><v>12500</v></c><c r="G7"><v>0</v></c><c r="H7"><v>0</v></c><c r="I7"><v>0</v></c><c r="J7"><v>0</v></c><c r="K7"><v>575.0798722044728</v></c><c r="L7"><v>0</v></c><c r="M7"><v>0</v></c><c r="N7"><v>0</v></c><c r="O7"><v>0</v></c><c r="P7"><v>13075.079872204473</v></c><c r="Q7"><v>585</v></c><c r="R7"><v>312.5</v></c><c r="S7"><v>100</v></c><c r="T7"><v>12077.579872204473</v></c><c r="U7"><v>249.0869808306709</v></c><c r="V7"><v>11828.492891373802</v></c><c r="W7"><v>0</v></c><c r="X7"><v>0</v></c><c r="Y7"><v>0</v></c><c r="Z7"><v>0</v></c><c r="AA7"><v>11828.492891373802</v></c></row><row r="8"><c r="A8" t="str"><v>Crisostomo, Frederick (60653)</v></c><c r="B8" t="str"><v>APP. DEV & DATABASE</v></c><c r="C8"><v>50000</v></c><c r="F8"><v>25000</v></c><c r="G8"><v>0</v></c><c r="H8"><v>0</v></c><c r="I8"><v>3594.2492012779553</v></c><c r="J8"><v>0</v></c><c r="K8"><v>575.0798722044728</v></c><c r="L8"><v>0</v></c><c r="M8"><v>3833.865814696486</v></c><c r="N8"><v>0</v></c><c r="O8"><v>0</v></c><c r="P8"><v>25335.46325878594</v></c><c r="Q8"><v>1147.5</v></c><c r="R8"><v>625</v></c><c r="S8"><v>100</v></c><c r="T8"><v>23462.96325878594</v></c><c r="U8"><v>2296.6926517571883</v></c><c r="V8"><v>21166.270607028753</v></c><c r="W8"><v>240</v></c><c r="X8"><v>10000</v></c><c r="Y8"><v>0</v></c><c r="Z8"><v>0</v></c><c r="AA8"><v>14850.463258785941</v></c></row><row r="9"><c r="A9" t="str"><v>Dag-Uman, Evelyn (60623)</v></c><c r="B9" t="str"><v>APP. DEV & DATABASE</v></c><c r="C9"><v>30000</v></c><c r="F9"><v>13849.840255591054</v></c><c r="G9"><v>0</v></c><c r="H9"><v>1150.1597444089457</v></c><c r="I9"><v>1078.2747603833866</v></c><c r="J9"><v>0</v></c><c r="K9"><v>345.0479233226837</v></c><c r="L9"><v>0</v></c><c r="M9"><v>0</v></c><c r="N9"><v>81.4696485623003</v></c><c r="O9"><v>0</v></c><c r="P9"><v>16341.853035143768</v></c><c r="Q9"><v>742.5</v></c><c r="R9"><v>375</v></c><c r="S9"><v>100</v></c><c r="T9"><v>15124.353035143768</v></c><c r="U9"><v>706.1029552715651</v></c><c r="V9"><v>14418.250079872203</v></c><c r="W9"><v>0</v></c><c r="X9"><v>1000</v></c><c r="Y9"><v>0</v></c><c r="Z9"><v>0</v></c><c r="AA9"><v>13418.250079872203</v></c></row><row r="10"><c r="A10" t="str"><v>Dela Paz, Jayson (60638)</v></c><c r="B10" t="str"><v>APP. DEV & DATABASE</v></c><c r="C10"><v>28000</v></c><c r="F10"><v>14000</v></c><c r="G10"><v>0</v></c><c r="H10"><v>0</v></c><c r="I10"><v>0</v></c><c r="J10"><v>0</v></c><c r="K10"><v>322.04472843450475</v></c><c r="L10"><v>0</v></c><c r="M10"><v>0</v></c><c r="N10"><v>22.364217252396163</v></c><c r="O10"><v>0</v></c><c r="P10"><v>14299.680511182109</v></c><c r="Q10"><v>652.5</v></c><c r="R10"><v>350</v></c><c r="S10"><v>100</v></c><c r="T10"><v>13197.180511182109</v></c><c r="U10"><v>417.0270766773163</v></c><c r="V10"><v>12780.153434504793</v></c><c r="W10"><v>0</v></c><c r="X10"><v>5000</v></c><c r="Y10"><v>0</v></c><c r="Z10"><v>0</v></c><c r="AA10"><v>7780.153434504793</v></c></row><row r="11"><c r="A11" t="str"><v>Doe, John (69999)</v></c><c r="B11" t="str"><v>APP. DEV & DATABASE</v></c><c r="C11"><v>20300</v></c><c r="F11"><v>9371.725239616613</v></c><c r="G11"><v>0</v></c><c r="H11"><v>778.2747603833866</v></c><c r="I11"><v>741.7931309904154</v></c><c r="J11"><v>0</v></c><c r="K11"><v>0</v></c><c r="L11"><v>0</v></c><c r="M11"><v>0</v></c><c r="N11"><v>42.156549520766774</v></c><c r="O11"><v>0</v></c><c r="P11"><v>10849.63658146965</v></c><c r="Q11"><v>495</v></c><c r="R11"><v>253.75</v></c><c r="S11"><v>100</v></c><c r="T11"><v>10000.88658146965</v></c><c r="U11"><v>0</v></c><c r="V11"><v>10000.88658146965</v></c><c r="W11"><v>0</v></c><c r="X11"><v>0</v></c><c r="Y11"><v>0</v></c><c r="Z11"><v>0</v></c><c r="AA11"><v>10000.88658146965</v></c></row><row r="12"><c r="A12" t="str"><v>Gutierrez, Lyca (60674)</v></c><c r="B12" t="str"><v>APP. DEV & DATABASE</v></c><c r="C12"><v>28000</v></c><c r="F12"><v>14000</v></c><c r="G12"><v>0</v></c><c r="H12"><v>0</v></c><c r="I12"><v>0</v></c><c r="J12"><v>0</v></c><c r="K12"><v>0</v></c><c r="L12"><v>0</v></c><c r="M12"><v>7514.376996805111</v></c><c r="N12"><v>0</v></c><c r="O12"><v>0</v></c><c r="P12"><v>6485.623003194889</v></c><c r="Q12"><v>292.5</v></c><c r="R12"><v>350</v></c><c r="S12"><v>100</v></c><c r="T12"><v>5743.123003194889</v></c><c r="U12"><v>0</v></c><c r="V12"><v>5743.123003194889</v></c><c r="W12"><v>0</v></c><c r="X12"><v>6000</v></c><c r="Y12"><v>0</v></c><c r="Z12"><v>0</v></c><c r="AA12"><v>-256.87699680511105</v></c></row><row r="13"><c r="A13" t="str"><v>Mangada, Liezle (60585)</v></c><c r="B13" t="str"><v>APP. DEV & DATABASE</v></c><c r="C13"><v>30000</v></c><c r="F13"><v>14424.920127795527</v></c><c r="G13"><v>0</v></c><c r="H13"><v>575.0798722044728</v></c><c r="I13"><v>1437.6996805111821</v></c><c r="J13"><v>0</v></c><c r="K13"><v>345.0479233226837</v></c><c r="L13"><v>0</v></c><c r="M13"><v>0</v></c><c r="N13"><v>11.980830670926517</v></c><c r="O13"><v>222.8434504792332</v></c><c r="P13"><v>16547.923322683706</v></c><c r="Q13"><v>742.5</v></c><c r="R13"><v>375</v></c><c r="S13"><v>100</v></c><c r="T13"><v>15330.423322683706</v></c><c r="U13"><v>737.0134984025559</v></c><c r="V13"><v>14593.40982428115</v></c><c r="W13"><v>0</v></c><c r="X13"><v>2000</v></c><c r="Y13"><v>0</v></c><c r="Z13"><v>0</v></c><c r="AA13"><v>12593.40982428115</v></c></row><row r="14"><c r="A14" t="str"><v>Manicio, Jaycion Ray (60686)</v></c><c r="B14" t="str"><v>APP. DEV & DATABASE</v></c><c r="C14"><v>31000</v></c><c r="F14"><v>15500</v></c><c r="G14"><v>0</v></c><c r="H14"><v>0</v></c><c r="I14"><v>0</v></c><c r="J14"><v>0</v></c><c r="K14"><v>713.0990415335464</v></c><c r="L14"><v>0</v></c><c r="M14"><v>0</v></c><c r="N14"><v>143.61022364217254</v></c><c r="O14"><v>0</v></c><c r="P14"><v>16069.488817891375</v></c><c r="Q14"><v>720</v></c><c r="R14"><v>387.5</v></c><c r="S14"><v>100</v></c><c r="T14"><v>14861.988817891375</v></c><c r="U14"><v>666.7483226837063</v></c><c r="V14"><v>14195.240495207669</v></c><c r="W14"><v>0</v></c><c r="X14"><v>10000</v></c><c r="Y14"><v>0</v></c><c r="Z14"><v>0</v></c><c r="AA14"><v>4195.240495207669</v></c></row><row r="15"><c r="A15" t="str"><v>Navaja, Redward (60551)</v></c><c r="B15" t="str"><v>APP. DEV & DATABASE</v></c><c r="C15"><v>35000</v></c><c r="F15"><v>17500</v></c><c r="G15"><v>0</v></c><c r="H15"><v>0</v></c><c r="I15"><v>0</v></c><c r="J15"><v>0</v></c><c r="K15"><v>805.111821086262</v></c><c r="L15"><v>0</v></c><c r="M15"><v>1341.85303514377</v></c><c r="N15"><v>128.59424920127796</v></c><c r="O15"><v>148.1629392971246</v></c><c r="P15"><v>16686.50159744409</v></c><c r="Q15"><v>742.5</v></c><c r="R15"><v>437.5</v></c><c r="S15"><v>100</v></c><c r="T15"><v>15406.50159744409</v></c><c r="U15"><v>748.4252396166136</v></c><c r="V15"><v>14658.076357827476</v></c><c r="W15"><v>2500</v></c><c r="X15"><v>1666.665</v></c><c r="Y15"><v>0</v></c><c r="Z15"><v>0</v></c><c r="AA15"><v>15491.411357827477</v></c></row><row r="16"><c r="A16" t="str"><v>Patawaran, Anjury (60687)</v></c><c r="B16" t="str"><v>APP. DEV & DATABASE</v></c><c r="C16"><v>30000</v></c><c r="F16"><v>15000</v></c><c r="G16"><v>0</v></c><c r="H16"><v>0</v></c><c r="I16"><v>1078.2747603833866</v></c><c r="J16"><v>0</v></c><c r="K16"><v>345.0479233226837</v></c><c r="L16"><v>0</v></c><c r="M16"><v>0</v></c><c r="N16"><v>0</v></c><c r="O16"><v>0</v></c><c r="P16"><v>16423.32268370607</v></c><c r="Q16"><v>742.5</v></c><c r="R16"><v>375</v></c><c r="S16"><v>100</v></c><c r="T16"><v>15205.822683706068</v></c><c r="U16"><v>718.3234025559102</v></c><c r="V16"><v>14487.499281150158</v></c><c r="W16"><v>120</v></c><c r="X16"><v>10000</v></c><c r="Y16"><v>0</v></c><c r="Z16"><v>0</v></c><c r="AA16"><v>4607.499281150158</v></c></row><row r="17"><c r="A17" t="str"><v>Pineda, Needheart (60599)</v></c><c r="B17" t="str"><v>APP. DEV & DATABASE</v></c><c r="C17"><v>40000</v></c><c r="F17"><v>20000</v></c><c r="G17"><v>0</v></c><c r="H17"><v>0</v></c><c r="I17"><v>0</v></c><c r="J17"><v>0</v></c><c r="K17"><v>920.1277955271565</v></c><c r="L17"><v>0</v></c><c r="M17"><v>1533.5463258785942</v></c><c r="N17"><v>0</v></c><c r="O17"><v>0</v></c><c r="P17"><v>19386.581469648565</v></c><c r="Q17"><v>877.5</v></c><c r="R17"><v>500</v></c><c r="S17"><v>100</v></c><c r="T17"><v>17909.081469648565</v></c><c r="U17"><v>1185.916293929713</v></c><c r="V17"><v>16723.165175718852</v></c><c r="W17"><v>0</v></c><c r="X17"><v>7000</v></c><c r="Y17"><v>0</v></c><c r="Z17"><v>0</v></c><c r="AA17"><v>10323.165175718852</v></c></row><row r="18"><c r="A18" t="str"><v>Roxas, Ronica (60578)</v></c><c r="B18" t="str"><v>APP. DEV & DATABASE</v></c><c r="C18"><v>32000</v></c><c r="F18"><v>16000</v></c><c r="G18"><v>0</v></c><c r="H18"><v>0</v></c><c r="I18"><v>0</v></c><c r="J18"><v>0</v></c><c r="K18"><v>736.1022364217251</v></c><c r="L18"><v>0</v></c><c r="M18"><v>0</v></c><c r="N18"><v>0</v></c><c r="O18"><v>0</v></c><c r="P18"><v>16736.102236421724</v></c><c r="Q18"><v>742.5</v></c><c r="R18"><v>400</v></c><c r="S18"><v>100</v></c><c r="T18"><v>15493.602236421724</v></c><c r="U18"><v>761.4903354632586</v></c><c r="V18"><v>14732.111900958465</v></c><c r="W18"><v>0</v></c><c r="X18"><v>0</v></c><c r="Y18"><v>0</v></c><c r="Z18"><v>0</v></c><c r="AA18"><v>14732.111900958465</v></c></row><row r="19"><c r="A19" t="str"><v>Tenorio, Mae (60714)</v></c><c r="B19" t="str"><v>APP. DEV & DATABASE</v></c><c r="C19"><v>25000</v></c><c r="F19"><v>12500</v></c><c r="G19"><v>0</v></c><c r="H19"><v>0</v></c><c r="I19"><v>0</v></c><c r="J19"><v>0</v></c><c r="K19"><v>0</v></c><c r="L19"><v>0</v></c><c r="M19"><v>1916.932907348243</v></c><c r="N19"><v>0</v></c><c r="O19"><v>0</v></c><c r="P19"><v>10583.067092651758</v></c><c r="Q19"><v>472.5</v></c><c r="R19"><v>312.5</v></c><c r="S19"><v>100</v></c><c r="T19"><v>9698.067092651758</v></c><c r="U19"><v>0</v></c><c r="V19"><v>9698.067092651758</v></c><c r="W19"><v>500</v></c><c r="X19"><v>2000</v></c><c r="Y19"><v>0</v></c><c r="Z19"><v>0</v></c><c r="AA19"><v>8198.067092651758</v></c></row></sheetData><ignoredErrors><ignoredError numberStoredAsText="1" sqref="A1:AA19"/></ignoredErrors></worksheet>PK��nx�K��K��xl/worksheets/sheet2.xml<?xml version="1.0" encoding="UTF-8" standalone="yes"?> <worksheet xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships"><dimension ref="A1:B4"/><sheetViews><sheetView workbookViewId="0"/></sheetViews><sheetData><row r="1"><c r="A1" t="str"><v>AHG - AUTOHUB GROUP BUSINESS AND CONSULTANCY SERVICES, INC</v></c></row><row r="2"><c r="A2" t="str"><v>ADJUSTMENT SUMMARY REPORT</v></c></row><row r="3"><c r="A3" t="str"><v xml:space="preserve">Covered Period : </v></c><c r="B3" t="str"><v>09/06/2024 - 09/20/2024</v></c></row><row r="4"><c r="A4" t="str"><v xml:space="preserve">Branch : </v></c><c r="B4" t="str"><v>AUTOHUB GROUP INC</v></c></row></sheetData><ignoredErrors><ignoredError numberStoredAsText="1" sqref="A1:B4"/></ignoredErrors></worksheet>PK��?��?��xl/worksheets/sheet3.xml<?xml version="1.0" encoding="UTF-8" standalone="yes"?> <worksheet xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships"><dimension ref="A1:D19"/><sheetViews><sheetView workbookViewId="0"/></sheetViews><sheetData><row r="1"><c r="A1" t="str"><v>AHG - AUTOHUB GROUP BUSINESS AND CONSULTANCY SERVICES, INC</v></c></row><row r="2"><c r="A2" t="str"><v>BENEFITS SUMMARY REPORT</v></c></row><row r="3"><c r="A3" t="str"><v xml:space="preserve">Covered Period : </v></c><c r="B3" t="str"><v>09/06/2024 - 09/20/2024</v></c></row><row r="4"><c r="A4" t="str"><v xml:space="preserve">Branch : </v></c><c r="B4" t="str"><v>AUTOHUB GROUP INC</v></c></row><row r="6"><c r="A6" t="str"><v>Meal</v></c></row><row r="7"><c r="A7" t="str"><v></v></c><c r="B7" t="str"><v>Employee</v></c><c r="C7" t="str"><v>Days/Month</v></c><c r="D7" t="str"><v>Amount</v></c></row><row r="8"><c r="A8" t="str"><v></v></c><c r="B8" t="str"><v>Crisostomo, Frederick (60653)</v></c><c r="C8"><v>4</v></c><c r="D8"><v>240</v></c></row><row r="9"><c r="A9" t="str"><v></v></c><c r="B9" t="str"><v>Patawaran, Anjury (60687)</v></c><c r="C9"><v>2</v></c><c r="D9"><v>120</v></c></row><row r="12"><c r="A12" t="str"><v>Loan Benefits</v></c></row><row r="13"><c r="A13" t="str"><v></v></c><c r="B13" t="str"><v>Employee</v></c><c r="C13" t="str"><v>Days/Month</v></c><c r="D13" t="str"><v>Amount</v></c></row><row r="14"><c r="A14" t="str"><v></v></c><c r="B14" t="str"><v>Navaja, Redward (60551)</v></c><c r="C14" t="str"><v>1/2</v></c><c r="D14"><v>2500</v></c></row><row r="17"><c r="A17" t="str"><v>Uniform Benefits</v></c></row><row r="18"><c r="A18" t="str"><v></v></c><c r="B18" t="str"><v>Employee</v></c><c r="C18" t="str"><v>Days/Month</v></c><c r="D18" t="str"><v>Amount</v></c></row><row r="19"><c r="A19" t="str"><v></v></c><c r="B19" t="str"><v>Tenorio, Mae (60714)</v></c><c r="C19" t="str"><v>1/2</v></c><c r="D19"><v>500</v></c></row></sheetData><ignoredErrors><ignoredError numberStoredAsText="1" sqref="A1:D19"/></ignoredErrors></worksheet>PK��t(��(��xl/worksheets/sheet4.xml<?xml version="1.0" encoding="UTF-8" standalone="yes"?> <worksheet xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships"><dimension ref="A1:D26"/><sheetViews><sheetView workbookViewId="0"/></sheetViews><sheetData><row r="1"><c r="A1" t="str"><v>AHG - AUTOHUB GROUP BUSINESS AND CONSULTANCY SERVICES, INC</v></c></row><row r="2"><c r="A2" t="str"><v>BENEFITS SUMMARY REPORT</v></c></row><row r="3"><c r="A3" t="str"><v xml:space="preserve">Covered Period : </v></c><c r="B3" t="str"><v>09/06/2024 - 09/20/2024</v></c></row><row r="4"><c r="A4" t="str"><v xml:space="preserve">Branch : </v></c><c r="B4" t="str"><v>AUTOHUB GROUP INC</v></c></row><row r="6"><c r="A6" t="str"><v>Absences</v></c></row><row r="7"><c r="A7" t="str"><v></v></c><c r="B7" t="str"><v>Employee</v></c><c r="C7" t="str"><v>Days</v></c><c r="D7" t="str"><v>Amount</v></c></row><row r="8"><c r="A8" t="str"><v></v></c><c r="B8" t="str"><v>Crisostomo, Frederick (60653)</v></c><c r="C8" t="str"><v>2.00</v></c><c r="D8" t="str"><v>3,833.87</v></c></row><row r="9"><c r="A9" t="str"><v></v></c><c r="B9" t="str"><v>Gutierrez, Lyca (60674)</v></c><c r="C9" t="str"><v>7.00</v></c><c r="D9" t="str"><v>7,514.38</v></c></row><row r="10"><c r="A10" t="str"><v></v></c><c r="B10" t="str"><v>Navaja, Redward (60551)</v></c><c r="C10" t="str"><v>1.00</v></c><c r="D10" t="str"><v>1,341.85</v></c></row><row r="11"><c r="A11" t="str"><v></v></c><c r="B11" t="str"><v>Pineda, Needheart (60599)</v></c><c r="C11" t="str"><v>1.00</v></c><c r="D11" t="str"><v>1,533.55</v></c></row><row r="12"><c r="A12" t="str"><v></v></c><c r="B12" t="str"><v>Tenorio, Mae (60714)</v></c><c r="C12" t="str"><v>2.00</v></c><c r="D12" t="str"><v>1,916.93</v></c></row><row r="14"><c r="A14" t="str"><v>Tardiness</v></c></row><row r="15"><c r="A15" t="str"><v></v></c><c r="B15" t="str"><v>Employee</v></c><c r="C15" t="str"><v>Minutes</v></c><c r="D15" t="str"><v>Amount</v></c></row><row r="16"><c r="A16" t="str"><v></v></c><c r="B16" t="str"><v>Dag-Uman, Evelyn (60623)</v></c><c r="C16"><v>34</v></c><c r="D16" t="str"><v>81.47</v></c></row><row r="17"><c r="A17" t="str"><v></v></c><c r="B17" t="str"><v>Dela Paz, Jayson (60638)</v></c><c r="C17"><v>10</v></c><c r="D17" t="str"><v>22.36</v></c></row><row r="18"><c r="A18" t="str"><v></v></c><c r="B18" t="str"><v>Doe, John (69999)</v></c><c r="C18"><v>26</v></c><c r="D18" t="str"><v>42.16</v></c></row><row r="19"><c r="A19" t="str"><v></v></c><c r="B19" t="str"><v>Mangada, Liezle (60585)</v></c><c r="C19"><v>5</v></c><c r="D19" t="str"><v>11.98</v></c></row><row r="20"><c r="A20" t="str"><v></v></c><c r="B20" t="str"><v>Manicio, Jaycion Ray (60686)</v></c><c r="C20"><v>58</v></c><c r="D20" t="str"><v>143.61</v></c></row><row r="21"><c r="A21" t="str"><v></v></c><c r="B21" t="str"><v>Navaja, Redward (60551)</v></c><c r="C21"><v>46</v></c><c r="D21" t="str"><v>128.59</v></c></row><row r="23"><c r="A23" t="str"><v>Undertime</v></c></row><row r="24"><c r="A24" t="str"><v></v></c><c r="B24" t="str"><v>Employee</v></c><c r="C24" t="str"><v>Minutes</v></c><c r="D24" t="str"><v>Amount</v></c></row><row r="25"><c r="A25" t="str"><v></v></c><c r="B25" t="str"><v>Mangada, Liezle (60585)</v></c><c r="C25"><v>93</v></c><c r="D25" t="str"><v>222.84</v></c></row><row r="26"><c r="A26" t="str"><v></v></c><c r="B26" t="str"><v>Navaja, Redward (60551)</v></c><c r="C26"><v>53</v></c><c r="D26" t="str"><v>148.16</v></c></row></sheetData><ignoredErrors><ignoredError numberStoredAsText="1" sqref="A1:D26"/></ignoredErrors></worksheet>PK��`��xl/metadata.xml<?xml version="1.0" encoding="UTF-8" standalone="yes"?> <metadata xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" xmlns:xlrd="http://schemas.microsoft.com/office/spreadsheetml/2017/richdata" xmlns:xda="http://schemas.microsoft.com/office/spreadsheetml/2017/dynamicarray"> <metadataTypes count="1"> <metadataType name="XLDAPR" minSupportedVersion="120000" copy="1" pasteAll="1" pasteValues="1" merge="1" splitFirst="1" rowColShift="1" clearFormats="1" clearComments="1" assign="1" coerce="1" cellMeta="1"/> </metadataTypes> <futureMetadata name="XLDAPR" count="1"> <bk> <extLst> <ext uri="{bdbb8cdc-fa1e-496e-a857-3c3f30c029c3}"> <xda:dynamicArrayProperties fDynamic="1" fCollapsed="0"/> </ext> </extLst> </bk> </futureMetadata> <cellMetadata count="1"> <bk> <rc t="1" v="0"/> </bk> </cellMetadata> </metadata>PK��^�PN��xl/workbook.xml<?xml version="1.0" encoding="UTF-8" standalone="yes"?> <workbook xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships"><workbookPr codeName="ThisWorkbook"/><sheets><sheet name="Employee Payroll" sheetId="1" r:id="rId1"/><sheet name="ADJUSTMENT SUMMARY" sheetId="2" r:id="rId2"/><sheet name="BENEFITS SUMMARY" sheetId="3" r:id="rId3"/><sheet name="DEDUCTIONS SUMMARY" sheetId="4" r:id="rId4"/></sheets></workbook>PK��Jj�L��L��_rels/.rels<?xml version="1.0" encoding="UTF-8" standalone="yes"?> <Relationships xmlns="http://schemas.openxmlformats.org/package/2006/relationships"><Relationship Id="rId2" Type="http://schemas.openxmlformats.org/package/2006/relationships/metadata/core-properties" Target="docProps/core.xml"/><Relationship Id="rId3" Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/extended-properties" Target="docProps/app.xml"/><Relationship Id="rId1" Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/officeDocument" Target="xl/workbook.xml"/></Relationships>PK��g&�\��docProps/app.xml<?xml version="1.0" encoding="UTF-8" standalone="yes"?> <Properties xmlns="http://schemas.openxmlformats.org/officeDocument/2006/extended-properties" xmlns:vt="http://schemas.openxmlformats.org/officeDocument/2006/docPropsVTypes"><Application>SheetJS</Application><HeadingPairs><vt:vector size="2" baseType="variant"><vt:variant><vt:lpstr>Worksheets</vt:lpstr></vt:variant><vt:variant><vt:i4>4</vt:i4></vt:variant></vt:vector></HeadingPairs><TitlesOfParts><vt:vector size="4" baseType="lpstr"><vt:lpstr>Employee Payroll</vt:lpstr><vt:lpstr>ADJUSTMENT SUMMARY</vt:lpstr><vt:lpstr>BENEFITS SUMMARY</vt:lpstr><vt:lpstr>DEDUCTIONS SUMMARY</vt:lpstr></vt:vector></TitlesOfParts></Properties>PK��֒\|Z��Z��docProps/core.xml<?xml version="1.0" encoding="UTF-8" standalone="yes"?> <cp:coreProperties xmlns:cp="http://schemas.openxmlformats.org/package/2006/metadata/core-properties" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:dcterms="http://purl.org/dc/terms/" xmlns:dcmitype="http://purl.org/dc/dcmitype/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/>PK��6�� [Content_Types].xml<?xml version="1.0" encoding="UTF-8" standalone="yes"?> <Types xmlns="http://schemas.openxmlformats.org/package/2006/content-types" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"><Default Extension="xml" ContentType="application/xml"/><Default Extension="bin" ContentType="application/vnd.ms-excel.sheet.binary.macroEnabled.main"/><Default Extension="vml" ContentType="application/vnd.openxmlformats-officedocument.vmlDrawing"/><Default Extension="data" ContentType="application/vnd.openxmlformats-officedocument.model+data"/><Default Extension="bmp" ContentType="image/bmp"/><Default Extension="png" ContentType="image/png"/><Default Extension="gif" ContentType="image/gif"/><Default Extension="emf" ContentType="image/x-emf"/><Default Extension="wmf" ContentType="image/x-wmf"/><Default Extension="jpg" ContentType="image/jpeg"/><Default Extension="jpeg" ContentType="image/jpeg"/><Default Extension="tif" ContentType="image/tiff"/><Default Extension="tiff" ContentType="image/tiff"/><Default Extension="pdf" ContentType="application/pdf"/><Default Extension="rels" ContentType="application/vnd.openxmlformats-package.relationships+xml"/><Override PartName="/xl/workbook.xml" ContentType="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet.main+xml"/><Override PartName="/xl/worksheets/sheet1.xml" ContentType="application/vnd.openxmlformats-officedocument.spreadsheetml.worksheet+xml"/><Override PartName="/xl/worksheets/sheet2.xml" ContentType="application/vnd.openxmlformats-officedocument.spreadsheetml.worksheet+xml"/><Override PartName="/xl/worksheets/sheet3.xml" ContentType="application/vnd.openxmlformats-officedocument.spreadsheetml.worksheet+xml"/><Override PartName="/xl/worksheets/sheet4.xml" ContentType="application/vnd.openxmlformats-officedocument.spreadsheetml.worksheet+xml"/><Override PartName="/xl/theme/theme1.xml" ContentType="application/vnd.openxmlformats-officedocument.theme+xml"/><Override PartName="/xl/styles.xml" ContentType="application/vnd.openxmlformats-officedocument.spreadsheetml.styles+xml"/><Override PartName="/docProps/core.xml" ContentType="application/vnd.openxmlformats-package.core-properties+xml"/><Override PartName="/docProps/app.xml" ContentType="application/vnd.openxmlformats-officedocument.extended-properties+xml"/><Override PartName="/xl/metadata.xml" ContentType="application/vnd.openxmlformats-officedocument.spreadsheetml.sheetMetadata+xml"/></Types>PK��3H\��\��xl/_rels/workbook.xml.relsPK��0�k��xl/theme/theme1.xmlPK��U��Z��Z�� "��xl/styles.xmlPK��P��X/��X/��('��xl/worksheets/sheet1.xmlPK��nx�K��K��V��xl/worksheets/sheet2.xmlPK��?��?��7Z��xl/worksheets/sheet3.xmlPK��t(��(��b��xl/worksheets/sheet4.xmlPK��`�� q��xl/metadata.xmlPK��^�PN��t��xl/workbook.xmlPK��Jj�L��L��v��_rels/.relsPK��g&�\��Yy��docProps/app.xmlPK��֒\|Z��Z��6\|��docProps/core.xmlPK��6�� }��[Content_Types].xmlPK�� M��

| ver. 1.4 | . | PHP 8.1.32 | Generation time: 0 | proxy | phpinfo | Settings